Dashboard 02 - WakeCountyRealEstate Dashboard - Creating Cards and Slicer 15

Step 1a:  Create Township Name Card


In Power BI Desktop, click on the page, WakeCountyRealEstate


Click inside the pane


Visualizations


Click the Card icon


Fields


Select the following:


A_KeyMeasures ->  .Measure_Township



Visualizations


Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Township Name 


Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 1061  , Y Position = 121 , Width = 438 , Height = 52

Under Format ->  Data Label ->  Color = #945231 , Text Size = 25 pt , Font = DIN (default)

Under Format -> Category ->  Set it to OFF

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #CCCCCC





Step 1b:  Create a blank text box


As part of the cards, there needs to be a blank text box.


Click on the Insert ribbon ->  Text  box



Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card to Township Name 

Under Format ->  General: X Position = 272  , Y Position = 120 , Width = 789 , Height = 52

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #CCCCCC, Radius = 0 px

All other visualizations settings are set to OFF.







Step 2:  Create Average House Prices Card

Click inside the pane

Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_AVG_Residentials_Prices



Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card = AVG House Prices

Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 0 , Y Position = 172, Width = 272 , Height = 159

Under Format ->  Data Label ->  Color = #000000 , Text Size = 25 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = #945231 , Text Size = 17 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px









Step 3:  Create AVG Price House Price/Sq.Ft. Card

To create remainder of the cards, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 2 and use it as a template.


Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste


Visualizations

Click the Card icon

Fields

Select the following:

A_KeyMeasures ->  .Transparent_AVG_ResidentialPrice_PerSqFt



Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card = AVG Price House Price/Sq.Ft.

Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 0 , Y Position = 331, Width = 272 , Height = 155

Under Format ->  Data Label ->  Color = #000000 , Text Size = 25 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = #945231 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px








Step 4:  Create AVG Apt Price/Sq.Ft. Card

To create the following card, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 3 and use it as a template.



Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste


Fields

Select the following:

A_KeyMeasures ->  .Transparent_AVG_AptUnitPrice_PerSqFt



Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card = AVG Apt Price/Sq.Ft.

Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 0 , Y Position = 640    , Width = 272 , Height = 155

Under Format ->  Data Label ->  Color = #000000 , Text Size = 25 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = ##1D0C4A , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px







Step 5:  Create YOY AVG Hse Price/Sq.Ft. Card

To create the following card, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 3 and use it as a template.


Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste


Fields

Select the following:

A_KeyMeasures ->  .Transparent_YOY_AVG_ResidentialPrice_PerSqFt


Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card = YOY AVG Hse Price/Sq.Ft.

Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 0 , Y Position = 485    , Width = 272 , Height = 155

Under Format ->  Data Label ->  Color = click on the letters fx ->  Format by = Color Scale , Based on field = .YOY_AVG_ResidentialPrice_PerSqFt% , Minimum = Custom = 0.00001 & color = #FF0000 , Maximum = 0 & color = #5B8F22 , Text Size = 25 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = #945231 , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px
















Step 6:  Create YOY AVG Apt Price/Sq.Ft. Card

To create the following card, copy and paste the AVG Price House Price/Sq.Ft. Card that was created in Step 3 and use it as a template.



Click the AVG House Price Card icon , press Ctrl+C to copy the card , press Ctrl+V to paste


Fields

Select the following:

A_KeyMeasures ->  .Transparent_YOY_AVG_AptUnitPrice_PerSqFt



Visualizations

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card = YOY AVG Apt Price/Sq.Ft.

Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General: X Position = 0 , Y Position = 796    , Width = 272 , Height = 155

Under Format ->  Data Label ->  Color = click on the letters fx ->  Format by = Color Scale , Based on field = .YOY_AVG_AptUnitPrice_PerSqFt% , Minimum = Custom = 0.00001 & color = #FF0000 , Maximum = 0 & color = #5B8F22 , Text Size = 25 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = #1D0C4A , Text Size = 15 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px








Step 7:  Create Year Slicer


If selected, de-select a visualization by clicking an empty area of the report page.

Visualizations

Click the Slicer icon

Fields

Select the following:

DateDimension ->  Date ->  Date Hierarchy ->  Year



Visualizations


Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Format ->  General ->  Outline Color = #605E5C , X Position = 1018  , Y Position = 0 , Width = 300 , Height = 120

Under Format -> Slider header ->  Set it to ON ->  Title Text = Years , Color = #252423 , Text Size = 12

Under Format ->  Numeric Inputs ->  Font Color = #252423, Text Size = 15 pt , Font = Segoe UI

Under Format -> Slider ->  Set it to ON ->  Color = #094780

Under Format -> Title ->  Set it to ON , Title Text = Years, Font Color = #1D0C4A , Background Color = E6E6E6 , Alignment = Center , Text Size = 20 pt , Font Family = DIN (Default)

Under Format ->  Background ->  Set it to ON , Color = #FFFFFF

Under Format ->  Border ->  Set it to ON , Color = 666666 , Radius 5 px





Step 8:  Create Last Refresh Date card



To create the following card to show the last time the dataset was refreshed, copy and paste the AVG House Price Card that was created in Step 3 and use it as a template.



To create a copy of the visual, click the AVG House Price Card visualization , press Ctrl+C to copy, and then press Ctrl+V to paste


Fields

Select the following:

A_KeyMeasures ->  .Last_Refreshed_Date



Visualizations

Format tab

To format the visual, beneath the Visualizations pane, select the Format pane.

Under Fields tab, click on the down arrow ->  Rename for this visual and rename the card = Last Refresh Date

Under Format ->  General: X Position = 0 , Y Position = 951    , Width = 272 , Height = 101

Under Format ->  Data Label ->  Color = #000000 , Text Size = 22 pt , Font = DIN (default)

Under Format -> Category ->  Set it to ON ->  Color = #1D0C4A , Text Size = 17 pt , Font = Segoe UI

Under Format -> Title ->  Set it to OFF

Under Format ->  Background ->  Set it to ON , Color = #E6E6E6

Under Format ->  Border ->  Set it to ON , Color = 666666, Radius = 5 px




When finished, save the project.







How to create a Card visualization in Power BI


How to create a Slicer visualization in Power BI